How does MYSQL discover and deal with the big trouble left by commit?
Data center operation and maintenance: to reduce trouble is to reduce failure
Trouble shooting for Pin S wait on X
Pin S wait on X is usually due to high parses. So check for high parsing sqls or tune application to

